package com.zeedev.provider;

import android.net.Uri;
import android.provider.BaseColumns;

public final class FlyingSaucer {
	
	public static final class Members implements BaseColumns {
		
		public static final Uri CONTENT_URI = 
			Uri.parse("content://com.zeedev.provider.FlyingSaucer/members");
		
		public static final String DEFAULT_SORT_ORDER = "modified DESC";
		
		public static final String MEMBER_ID = "memberId";
		public static final String USERNAME = "username";
		public static final String PASSWORD = "password";
		public static final String STORE_NUMBER = "storeNumber";
		public static final String CARD_NUMBER = "cardNumber";
		
	}
	
	public static final class Stores implements BaseColumns {
		
		public static final Uri CONTENT_URI = 
			Uri.parse("content://com.zeedev.provider.FlyingSaucer/stores");
		
		public static final String DEFAULT_SORT_ORDER = Stores.NAME + " ASC";
		
		public static final String STORES_KEY = "stores_key";	
		public static final String NAME = "storeName";
		public static final String URL_NAME = "storeUrlName";
		public static final String URL = "storeUrl";
		public static final String NUMBER = "storeNumber";
		public static final String CREATION_DATE = "stores_creation_date";
		public static final String UPDATED_DATE = "stores_updated_date";
		
		public static final class StoreBeer implements BaseColumns {
        	public static final String CONTENT_TYPE = "vnd.android.cursor.dir/vnd.flyingsaucer.storebeer";
        	public static final String CONTENT_ITEM_TYPE = "vnd.android.cursor.item/vnd.flyingsaucer.storebeer";

        	public static final Uri CONTENT_URI = Uri.parse("content://" + "com.zeedev.provider.FlyingSaucer" + "/stores/beers");
        	public static final Uri FILTER_CONTENT_URI = Uri.parse("content://" + "com.zeedev.provider.FlyingSaucer" + "/stores/beers/filter");
        	
        	public static final String STORE_BEER_KEY = "store_beer_key";
        	public static final String BEER_DB_ID = "storebeer_beerDbId";
        	public static final String STORE_DB_ID = "storebeer_storeDbId";
        	//virtual
//        	public static final String VIRTUAL_STORE_DB_ID = "BeersStoresStoreNumber";
//        	public static final String VIRTUAL_BEER_DB_ID = "BeersStoresBeerId";
        	

        	public static final String DEFAULT_SORT_ORDER = _ID + " DESC";//FlyingSaucerConv.Beers.NAME + " DESC";
    		
    		public static final String CREATION_DATE = "store_beer_creation_date";
    		public static final String UPDATED_DATE = "store_beer_updated_date";
        	
        	public static final String ACTIVE = "store_beer_active";
		}
	}
	
	public static final class Beers implements BaseColumns {

		public static final Uri CONTENT_URI = Uri
				.parse("content://com.zeedev.provider.FlyingSaucer/beers");

		public static final String DEFAULT_SORT_ORDER = Beers.NAME + " ASC";

		public static final String BEER_ID = "beerId";
		public static final String COUNTRY_ID = "countryId";
		public static final String BREWER_ID = "brewerId";
		public static final String STYLE_ID = "styleId";

		public static final String RAW_NAME = "rawName";
		// child
		public static final String NAME = "name";
		public static final String CAN = "can";
		public static final String NAME_SUBSCRIPT = "nameSubscript";

		public static final String CONTAINER = "container";
		// child
		public static final String BOTTLE = "draught";
		public static final String DRAUGHT = "bottle";

		public static final String DESCRIPTION = "description";
		public static final String CITY = "city";
		public static final String COUNTRY_NAME = "countryName";
		public static final String STYLE_NAME = "styleName";
		public static final String BREWER_NAME = "brewerName";
		public static final String AVERAGE_RATING = "averageRating";

		// DB Layered

		// Modified Externally only
//		public static final String INTERNAL_DATE_ADDED = "internalDateAdded";
		public static final String DB_ID = "_id";
//		public static final String STATUS = "status";

		// Internally Modified
//		public static final String COMMENTS = "comments";
//		public static final String RATING = "rating";

//		public static final String DATE_ADDED = "dateAdded";
		// child
		// public static final String DATE_ADDED_RAW = "dateAddedRaw";
//		public static final String SIMPLE_DATE = "simpleDate";
//		public static final String TASTED = "tasted";

//		public static final String MEMBER_ID = "memberId";
		
		//NON-COUNTED, VIRTUAL PROPERTIES
		public static final String SIMPLE_INTERNAL_DATE = "simpleInternalDate"; 
		public static final String NEW_SIMPLE_DATE = "newSimpleDate";
		public static final String SIMPLE_INTERNAL_DATE_2 = "simpleInternalDate2";
		public static final String DESCRIPTION_VALID = "descriptionValid";
		
		public static final String GROUP_BY = "groupBy";
		
//		public static final String STATUS_ACTIVE = "statusActive";
//		public static final String STATUS_INACTIVE = "statusInActive";
		
//		public static final String[] PROPERTIES_LIST = { 
//			BEER_ID, COUNTRY_ID, BREWER_ID, STYLE_ID,
//			RAW_NAME, NAME, NAME_SUBSCRIPT,
//			CONTAINER, BOTTLE, DRAUGHT, CAN,
//			DATE_ADDED, SIMPLE_DATE, TASTED,
//			DESCRIPTION, CITY, COUNTRY_NAME,
//			STYLE_NAME, BREWER_NAME, 
//			COMMENTS, RATING, AVERAGE_RATING,			
//			INTERNAL_DATE_ADDED, DB_ID , MEMBER_ID, STATUS
//			};
//	
//		public static final DB_TYPES[] TYPES_LIST = { 
//			DB_TYPES.DB_INTEGER, DB_TYPES.DB_INTEGER, DB_TYPES.DB_INTEGER, DB_TYPES.DB_INTEGER,
//			DB_TYPES.DB_STRING, DB_TYPES.DB_STRING, DB_TYPES.DB_STRING,
//			DB_TYPES.DB_STRING, DB_TYPES.DB_BOOLEAN, DB_TYPES.DB_BOOLEAN, DB_TYPES.DB_BOOLEAN,
//			DB_TYPES.DB_DATE, DB_TYPES.DB_STRING, DB_TYPES.DB_BOOLEAN,
//			DB_TYPES.DB_STRING, DB_TYPES.DB_STRING, DB_TYPES.DB_STRING,
//			DB_TYPES.DB_STRING, DB_TYPES.DB_STRING, 
//			DB_TYPES.DB_STRING, DB_TYPES.DB_INTEGER, DB_TYPES.DB_INTEGER,			
//			DB_TYPES.DB_DATE, DB_TYPES.DB_KEY , DB_TYPES.DB_INTEGER, DB_TYPES.DB_STRING
//			};

	}

}
